Timestamp

The data is taken from a 13-year range from 2008 to 2021, the last year where data was recorded from OECD.

Data source

The source used was data from Organisation for Economic Cooperation and Development (OECD). It contained data about imports and exports trade values of multiple countries, on top of various sectors of choice.

Link to the source , Globalisation -> Trade by Enterprise Characteristics -> ISIC rev4 -> TEC by partner zones and countries.

Metadata

Actions Performed

  1. Export the dataset as a CSV file.
  2. Load it in a data frame using pandas (Python library).
  3. Selected only the rows that were associated with the TOTAL sector, since we weren’t interested in any specific sector of those provided.
  4. Dropped not useful columns.
  5. Searched online for the URL of the country flags and added a column to contain them.
  6. Split the dataframe into two, one for the imports and one for the exports, then saved them in their respective CSV files.
  7. Loaded it on Flourish as data of a ‘Bar Chart Race’.
  8. Matched the graph parameters to the columns. The animation based on the year, the y-axis describing the country by its name and flag.
  9. Added a line plot below to show additional trend insights. It also works as an intuitive way to move the graph on the timeline.
  10. Repeated the process for the exports.